Release 10.1A: OpenEdge Data Management:
Database Administration

Eliminating database fragmentation

You can eliminate database fragmentation two ways:

Dump and reload the database.

Dumping and reloading the database creates a new starting version of the database and loads the table contents into this new database. During the loading stage the Data tool (either the Data Dictionary or the Data Administration tool) or the 4GL procedure repartitions the disk, removing any gaps created when database elements were deleted, thereby more efficiently allocating disk space. For instructions, see Chapter 15, " Dumping and Loading."

Move individual tables and indexes.

You can use PROUTIL with the TABLEMOVE and IDXMOVE qualifiers to move tables and indexes from one storage area to another while the database remains online. As a result, disk space is efficiently allocated and gaps are removed. For more information about moving tables and indexes, see Chapter 14, " Maintaining Database Structure."